USE [NewHis]
GO

/****** Object:  Table [dbo].[ZZ_ORDER_MX]    Script Date: 11/06/2020 08:58:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ZZ_ORDER_MX](
	[mxid] [int] IDENTITY(1,1) NOT NULL,
	[orderid] [varchar](50) NOT NULL,
	[id] [varchar](50) NULL,
	[xh] [varchar](50) NULL,
	[type] [varchar](50) NOT NULL,
	[item] [varchar](50) NOT NULL,
	[amount] [numeric](10, 2) NULL,
	[price] [numeric](10, 2) NOT NULL,
	[quantity] [int] NOT NULL,
	[unit] [varchar](50) NULL,
	[doctor] [varchar](50) NULL,
	[ysdm] [varchar](50) NULL,
	[ksdm] [varchar](50) NULL,
	[presCode] [varchar](50) NULL,
	[sfxm] [varchar](50) NULL,
	[brid] [varchar](20) NULL,
	[createTime] [datetime] NOT NULL,
 CONSTRAINT [PK_ZZ_ORDER_MX] PRIMARY KEY CLUSTERED 
(
	[mxid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'待缴费' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZZ_ORDER_MX'
GO

ALTER TABLE [dbo].[ZZ_ORDER_MX] ADD  CONSTRAINT [DF_ZZ_ORDER_MX_amount]  DEFAULT ((0)) FOR [amount]
GO


